{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":8,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:F3)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 August 2018",{"$f":"SUM(C4:F4)","v":423450000},115000000,286850000,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 August 2018",423450000,115000000,286850000,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",39614786.810000002,39614786.810000002,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Stated Amount as at Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Bond Factor at Payment Date:  16 November 2018",null,0.65552359295652174,1,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.6850000000000002E-2,3.0350000000000002E-2,3.6549999999999999E-2,4.2050000000000004E-2]
["Days in Coupon Period",null,92,92,92,92]
["Coupon Entitlement to be paid out on the current Payment Date: 16 November 2018",null,778282.19,2194363.21,103641.78,109698.66]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C25:F25)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 November 2018",{"$f":"SUM(C26:F26)","v":383835213.19},75385213.189999998,286850000,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",27133674.77,27133674.77,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  18 February 2019",356701538.42000002,48251538.420000002,286850000,11250000,10350000]
["Stated Amount as at Payment Date:  18 February 2019",356701538.42000002,48251538.420000002,286850000,11250000,10350000]
["Bond Factor at Payment Date:  18 February 2019",null,0.41957859495652178,1,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.6710000000000001E-2,3.0210000000000001E-2,3.6409999999999998E-2,4.1910000000000003E-2]
["Days in Coupon Period",null,94,94,94,94]
["Coupon Entitlement to be paid out on the current Payment Date: 18 February 2019",null,518555.26,2231724.44,105489.25,111710.24]

{"sheet":"Cumulative Defaults","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2018-10-01",0,0,0]
["2019-01-01",{"$f":"B4+'Collateral Tables'!E9/450000000","v":0},{"$f":"+C4+'Collateral Tables'!E23/450000000","v":0},{"$f":"B5-C5","v":0}]
["2019-04-01"]
["2019-07-01"]
["2019-10-01"]

{"sheet":"Collateral Tables","index":2,"n_rows":238,"n_cols":11,"rows_kept":238,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2018-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2018-01-31",null,null,null,"2018-10-31"]
[]
[null,"Opening Balance",null,null,{"$f":"'[2]18 Feb 19'!M163","v":410385213.19},null,null,null,449999896.88999999]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([3]Sheet1!$B$3+[4]Sheet1!$B$3+[5]Sheet1!$B$3),'[2]18 Feb 19'!H23)","v":25925049.640000001},null,null,null,32152734.129999999]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[2]18 Feb 19'!H23-'Collateral Tables'!E7","v":1208625.1300000101},null,null,null,7461949.5699999668]
[{"$f":"SUM(I9)","v":0},"Charge-Offs",null,null,{"$f":"'[2]18 Feb 19'!$H37","v":0},null,null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":383251538.42000002},null,null,null,410385213.19]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[6]Summary!$D$4","v":3359},null,null,null,3402]
[null,"Dollar value of contracts",null,null,{"$f":"[6]Summary!$G$5","v":383251538.41999996},null,null,null,410385213.18999952]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[6]Summary!$B$19","v":43},null,null,null,64]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[6]Summary!$B$20","v":6683029.9000000004},null,null,null,8769089.4699999988]
[]
[{"$f":"SUM(I23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[6]Summary!$C$16","v":0},null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[7]Sheet1!$W$3361","v":54.130152888845871},null,null,null,53.786897918104366]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[7]Sheet1!$X$3361","v":39.110875570193862},null,null,null,41.776292365564615]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[7]Sheet1!$AI$3361","v":3.9775154630899499E-2},null,null,null,3.9736399863039409E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":15.019277318652009},null,null,null,12.010605552539751]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":114096.91527835664},null,null,null,120630.57412992344]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[7]Sheet1!$AA$3361/100","v":2.5471722602341703E-2},null,null,null,2.550199740116188E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP(A34,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3354},{"$f":"IFERROR(VLOOKUP(A34,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":193610.88999999998},{"$f":"F34/F$50","v":5.051796812041092E-4},null,3400,279239.7,6.8043314189957925E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP(A35,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP(A35,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":8888.9800000000032},{"$f":"F35/F$50","v":2.3193592481444121E-5},null,1,45938.869999999995,1.1194085099438339E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP(A36,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP(A36,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":16836.879999999994},4.3931669705520386E-5,null,1,2144.1999999999953,5.2248471218851559E-6]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP(A37,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A37,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP(A38,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A38,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP(A39,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A39,'[8]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3359},{"$f":"SUM(F34:F39)","v":219336.75},{"$f":"SUM(G34:G39)","v":5.7230494339107374E-4},null,3402,327322.77,7.9759884001584784E-4]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":6.7125262186964514E-5},null,null,"> 30 days",1.1716569811626855E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP(A44,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3354},{"$f":"IFERROR(VLOOKUP(A44,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":382732142.23999995},{"$f":"F44/F$50","v":0.99864476426594062},null,3400,410108423.92999953,0.99932553793093948]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP(A45,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP(A45,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":196286.38},{"$f":"F45/F$50","v":5.1216070993273489E-4},null,1,205758.3,5.0137844490205435E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP(A46,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP(A46,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":323109.8},8.4307502412660511E-4,null,1,71030.959999999992,1.7308362415853951E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP(A47,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A47,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":0},{"$f":"F47/F$50","v":0},null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP(A48,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A48,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0},null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP(A49,'[8]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A49,'[8]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3359},{"$f":"SUM(F44:F49)","v":383251538.41999996},{"$f":"SUM(G44:G49)","v":1},null,3402,410385213.18999952,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":1.35523573405934E-3},null,null,"> 30 days",6.7446206906059385E-4]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":0},null,null,">90 days",0]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.28738603144052582},{"$f":"IFERROR(VLOOKUP(A55,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":110141138.66999999},null,null,0.28736145911134803,117928893.66000003]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.20800308285426566},{"$f":"IFERROR(VLOOKUP(A56,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":79717501.500000015},null,null,0.2030790640631952,83340645.00000003]
["QLD","Queensland",null,null,0.12170686868550314,{"$f":"IFERROR(VLOOKUP(A57,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":46644344.659999989},null,null,0.12788745367319404,52483119.93999999]
["SA","South Australia",null,null,0.18110694805335675,{"$f":"IFERROR(VLOOKUP(A58,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":69409516.459999979},null,null,0.17726510863908634,72746979.399999961]
["NT","Northern Territory",null,null,0,{"$f":"IFERROR(VLOOKUP(A59,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0,0]
["ACT","Australian Capital Territory",null,null,1.5384269621740196E-4,{"$f":"IFERROR(VLOOKUP(A60,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":58960.45},null,null,1.5794933130300096E-4,64820.069999999992]
["TAS","Tasmania",null,null,8.4380108774828634E-3,{"$f":"IFERROR(VLOOKUP(A61,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":3233880.6500000004},null,null,8.4309414150312498E-3,3459933.69]
["WA","Western Australia",null,null,0.19320521539264851,{"$f":"IFERROR(VLOOKUP(A62,'[8]Geographic '!$A$1:$C$9,3,FALSE),0)","v":74046196.029999986},null,null,0.19581802376684221,80360821.430000022]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1.0000000000000002},{"$f":"SUM(F55:F62)","v":383251538.4199999},null,null,1,410385213.19]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0},null,null,null,0]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.92874675511393878},{"$f":"IFERROR(VLOOKUP(A66,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":355943622.69999987},null,null,0.92796491411031079,380823079.10999954]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":7.1253244886061357E-2},{"$f":"IFERROR(VLOOKUP(A67,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":27307915.719999999},null,null,7.2035085889689154E-2,29562134.080000013]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP(A68,'[8]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0},null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1.0000000000000002},{"$f":"SUM(F66:F68)","v":383251538.41999984},{"$f":"F63-F69","v":0},null,1,410385213.18999958,0]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$104,0)","v":0.1007218431245978},{"$f":"IFERROR(VLOOKUP(A72,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":38601801.330000013},null,null,0.10051494735728245,41249848.099999994]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,9.8382964059179165E-2,{"$f":"IFERROR(VLOOKUP(A73,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":37705422.329999991},null,null,0.10508305251737765,43124530.910000004]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,1.2975684091188728E-2,{"$f":"IFERROR(VLOOKUP(A74,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":4972950.8900000006},null,null,1.318187026757088E-2,5409644.6399999997]
["4WD Vehicle","4WD Vehicle",null,null,3.9917368011279063E-3,{"$f":"IFERROR(VLOOKUP(A75,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":1529839.27},null,null,3.7864806529483031E-3,1553915.6700000002]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,4.6421141121430046E-2,{"$f":"IFERROR(VLOOKUP(A76,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":17790973.749999993},null,null,4.6930562093822771E-2,19259608.729999997]
["BACKHOE","BACKHOE",null,null,7.4072842908954988E-4,{"$f":"IFERROR(VLOOKUP(A77,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":283885.30999999994},null,null,7.2330018348534613E-4,296831.69999999995]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,2.4731878491802983E-2,{"$f":"IFERROR(VLOOKUP(A78,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":9478530.4800000042},null,null,2.5012008206172172E-2,10264558.319999998]
["COMBINES","COMBINES",null,null,0.33365369818780866,{"$f":"IFERROR(VLOOKUP(A79,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":127873293.13000005},null,null,0.32706074703977811,134220894.40000004]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,1.3198669053890551E-2,{"$f":"IFERROR(VLOOKUP(A80,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":5058410.2200000007},null,null,1.3428185014669721E-2,5510728.5699999984]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,7.3054456912100159E-4,{"$f":"IFERROR(VLOOKUP(A81,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":279982.32999999996},null,null,7.2181487168460697E-4,296222.15000000002]
["CRAWLER EXCAVATOR","CRAWLER EXCAVATOR",null,null,1.3548093509046269E-2,{"$f":"IFERROR(VLOOKUP(A82,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":5192327.68},null,null,1.3638023520620305E-2,5596843.1899999995]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.3427300647546348E-2,{"$f":"IFERROR(VLOOKUP(A83,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":5146033.6300000008},null,null,1.2948548751779157E-2,5313892.9399999995]
["DRILL","DRILL",null,null,9.270036109043831E-4,{"$f":"IFERROR(VLOOKUP(A84,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":355275.56},null,null,8.6571238090762915E-4,355275.56]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,3.0035422812537088E-4,{"$f":"IFERROR(VLOOKUP(A85,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":115111.22000000004},null,null,3.1812656938873664E-4,130554.44000000005]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,2.5778117005686193E-4,{"$f":"IFERROR(VLOOKUP(A86,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":98795.03},null,null,2.4952117354333362E-4,102399.79999999999]
["FRONT END LOADER","FRONT END LOADER",null,null,1.1902396318631322E-3,{"$f":"IFERROR(VLOOKUP(A87,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":456161.17},null,null,1.1590133482216555E-3,475641.93999999994]
["FRONTS","FRONTS",null,null,4.3155367798875582E-3,{"$f":"IFERROR(VLOOKUP(A88,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":1653936.1099999999},null,null,4.6322082007371939E-3,1900989.7500000002]
["GRADER","GRADER",null,null,7.1412196054923256E-4,{"$f":"IFERROR(VLOOKUP(A89,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":273688.33999999997},null,null,6.9452273337158605E-4,285021.85999999993]
["HARVESTERS - Other","HARVESTERS - Other",null,null,1.0143172904213803E-2,{"$f":"IFERROR(VLOOKUP(A90,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3887386.62},null,null,1.0046950273744581E-2,4123119.83]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,1.2544691718187515E-3,{"$f":"IFERROR(VLOOKUP(A91,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":480777.23999999993},null,null,1.230692855802697E-3,505058.14999999985]
["MIDI CRAWLER EXCAVATOR","MIDI CRAWLER EXCAVATOR",null,null,8.2862558441181575E-4,{"$f":"IFERROR(VLOOKUP(A92,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":317572.03000000003},null,null,8.4510561992259174E-4,346818.85000000003]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,1.7063660036331689E-2,{"$f":"IFERROR(VLOOKUP(A93,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":6539673.9599999944},null,null,1.7348859415906182E-2,7119715.3700000001]
["OTHER AG","OTHER AG",null,null,9.0732938590039405E-3,{"$f":"IFERROR(VLOOKUP(A94,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3477353.8299999996},null,null,8.8496612530689859E-3,3631770.1199999992]
["OTHER CE","OTHER CE",null,null,1.4623534254044188E-4,{"$f":"IFERROR(VLOOKUP(A95,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":56044.920000000027},null,null,1.5155923751863776E-4,62197.670000000027]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.19582862291801678,{"$f":"IFERROR(VLOOKUP(A96,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":75051621.000000015},null,null,0.19333381135559227,79341337.390000001]
["SCRAPERS","SCRAPERS",null,null,7.1696862883528225E-4,{"$f":"IFERROR(VLOOKUP(A97,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":274779.32999999996},null,null,7.3633150096004277E-4,302179.55999999994]
["SKID STEER LOADER","SKID STEER LOADER",null,null,1.6469757997638352E-2,{"$f":"IFERROR(VLOOKUP(A98,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":6312060.0899999989},null,null,1.6641691636287276E-2,6829504.1699999953]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,2.203169760207638E-4,{"$f":"IFERROR(VLOOKUP(A99,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":84436.819999999992},null,null,2.3410519412530575E-4,96073.309999999969]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,7.0390038122785506E-2,{"$f":"IFERROR(VLOOKUP(A100,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":26977090.399999999},null,null,7.1966060766245121E-2,29533807.190000009]
["TRENCHERS","TRENCHERS",null,null,3.3897364257317355E-4,{"$f":"IFERROR(VLOOKUP(A101,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":129912.17},null,null,3.5485779048422244E-4,145628.39000000001]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,1.0603504207063422E-3,{"$f":"IFERROR(VLOOKUP(A102,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":406380.92999999993},null,null,1.1130656157158311E-3,456785.67000000004]
["WHEEL LOADERS","WHEEL LOADERS",null,null,6.2361949278877974E-3,{"$f":"IFERROR(VLOOKUP(A103,[8]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":2390031.2999999998},null,null,6.1986026012644489E-3,2543814.85]
[null,"Total",null,null,{"$f":"SUM(E72:E103)","v":0.99999999999999989},{"$f":"SUM(F72:F103)","v":383251538.42000008},{"$f":"F69-F104","v":0},null,0.99999999999999978,410385213.19000012,-5.3644180297851563E-7]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F107/F$118,0)","v":2.555686834390767E-2},{"$f":"IFERROR(VLOOKUP(A107,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":9794709.1100000124},null,null,2.0816799035214772E-2,8542906.5099999998]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F108/F$118,0)","v":8.1715914929164135E-2},{"$f":"IFERROR(VLOOKUP(A108,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":31317750.109999999},null,null,7.8179603306383891E-2,32083753.169999979]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,7.659304401233985E-2,{"$f":"IFERROR(VLOOKUP(A109,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":29354401.950000018},null,null,7.4406360898444046E-2,30535270.280000035]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,5.8935603371921885E-2,{"$f":"IFERROR(VLOOKUP(A110,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":22587160.660000004},null,null,5.940096749712527E-2,24377278.710000012]
["$100,001 - $125,000","$100,001 to $125,000",null,null,5.1387226601077245E-2,{"$f":"IFERROR(VLOOKUP(A111,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":19694233.650000002},null,null,5.1689211960419867E-2,21212488.270000003]
["$125,001 - $150,000","$125,001 to $150,000",null,null,4.5620575359150553E-2,{"$f":"IFERROR(VLOOKUP(A112,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17484155.689999994},null,null,4.2201208774990076E-2,17318752.059999999]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.10161435578458648,{"$f":"IFERROR(VLOOKUP(A113,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":38943858.18},null,null,9.5551640116831357E-2,39212980.199999988]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.22285078244461629,{"$f":"IFERROR(VLOOKUP(A114,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":85407905.209999919},null,null,0.21822218533136511,89555158.049999952]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.1677875304430721,{"$f":"IFERROR(VLOOKUP(A115,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":64304829.169999972},null,null,0.16993880933938918,69740374.499999985]
["$400,001 - $500,000","$400,001 to $500,000",null,null,9.1736482298136746E-2,{"$f":"IFERROR(VLOOKUP(A116,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":35158147.970000006},null,null,0.1000432276320633,41056261.29999999]
["$500,001+","$500,000+",null,null,7.6201616412026829E-2,{"$f":"IFERROR(VLOOKUP(A117,'[8] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":29204386.720000003},null,null,8.9549986107773122E-2,36749990.140000008]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E107:E117)","v":0.99999999999999989},{"$f":"SUM(F107:F117)","v":383251538.42000002},{"$f":"F104-F118","v":0},null,1,410385213.18999994,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F121/F$131,0)","v":0.87042987442471642},{"$f":"IFERROR(VLOOKUP(A121,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":333593588.45999986},null,null,0.87028056701606027,357150276.02999955]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F122/F$131,0)","v":0},{"$f":"IFERROR(VLOOKUP(A122,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,0,""]
["6 to 10","06 to 10",null,null,1.9631919629125132E-3,{"$f":"IFERROR(VLOOKUP(A123,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":752396.34},null,null,1.9054699703275168E-3,781976.70000000007]
["11 to 15","11 to 15",null,null,2.0210916652633024E-3,{"$f":"IFERROR(VLOOKUP(A124,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":774586.49},null,null,1.9445128244192939E-3,797999.31]
["16 to 20","16 to 20",null,null,2.3728003904407664E-2,{"$f":"IFERROR(VLOOKUP(A125,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":9093794},null,null,2.4046790558779521E-2,9868447.2700000014]
["21 to 25","21 to 25",null,null,1.116499111168787E-2,{"$f":"IFERROR(VLOOKUP(A126,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":4279000.0200000005},null,null,1.0535203391936823E-2,4323491.6899999995]
["26 to 30","26 to 30",null,null,4.2894833606601665E-2,{"$f":"IFERROR(VLOOKUP(A127,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":16439510.969999997},null,null,4.1979094851119766E-2,17227599.789999995]
["31 to 35","31 to 35",null,null,1.3683446494748196E-2,{"$f":"IFERROR(VLOOKUP(A128,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":5244201.92},null,null,1.6827689297866461E-2,6905834.8600000003]
["36 to 40","36 to 40",null,null,2.1923568694960083E-2,{"$f":"IFERROR(VLOOKUP(A129,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":8402241.4299999997},null,null,2.1031024005253609E-2,8630821.2699999996]
["41+ %","41+%",null,null,1.2190998134702289E-2,{"$f":"IFERROR(VLOOKUP(A130,'[8]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":4672218.790000001},null,null,1.1449648084236829E-2,4698766.2700000005]
[null,null,null,null,{"$f":"SUM(E121:E130)","v":0.99999999999999989},{"$f":"SUM(F121:F130)","v":383251538.41999984},{"$f":"F118-F131","v":0},null,1,410385213.18999952,0]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B134,2)&LEFT(B134,4)","v":"Q42018"},"2018Q4",null,null,{"$f":"F134/F$157","v":0},{"$f":"IFERROR(VLOOKUP(A134,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":0},null,null,3.8855875620005314E-3,1594587.68]
["Q12019","2019Q1",null,null,5.4528955542241901E-3,{"$f":"IFERROR(VLOOKUP(A135,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":2089830.6099999999},null,null,5.2262312117152647E-3,2144768.0100000002]
[{"$f":"RIGHT(B136,2)&LEFT(B136,4)","v":"Q22019"},"2019Q2",null,null,8.2608842564655988E-4,{"$f":"IFERROR(VLOOKUP(A136,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":316599.65999999992},null,null,9.2270349376522595E-4,378663.87]
[{"$f":"RIGHT(B137,2)&LEFT(B137,4)","v":"Q32019"},"2019Q3",null,null,2.0568520174761096E-3,{"$f":"IFERROR(VLOOKUP(A137,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":788291.7},null,null,2.1244020300418666E-3,871823.17999999993]
["Q42019","2019Q4",null,null,1.7471410363034221E-3,{"$f":"IFERROR(VLOOKUP(A138,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":669594.48999999976},null,null,2.1337729817145802E-3,875668.87999999977]
["Q12020","2020Q1",null,null,1.2848810601781589E-2,{"$f":"IFERROR(VLOOKUP(A139,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":4924326.4300000006},null,null,1.280247655406515E-2,5253947.0700000012]
["Q22020","2020Q2",null,null,1.6098489507532333E-2,{"$f":"IFERROR(VLOOKUP(A140,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":6169770.8699999955},null,null,1.6080003805948036E-2,6598995.7899999944]
["Q32020","2020Q3",null,null,1.6127886545431916E-2,{"$f":"IFERROR(VLOOKUP(A141,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":6181037.3300000029},null,null,1.7146812272551611E-2,7036798.209999999]
["Q42020","2020Q4",null,null,2.9240167374668523E-2,{"$f":"IFERROR(VLOOKUP(A142,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":11206339.130000006},null,null,3.198479874059907E-2,13126088.449999988]
["Q12021","2021Q1",null,null,5.500550864559791E-2,{"$f":"IFERROR(VLOOKUP(A143,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":21080945.810000014},null,null,5.7437186312770339E-2,23571371.949999999]
["Q22021","2021Q2",null,null,3.2174061064007768E-2,{"$f":"IFERROR(VLOOKUP(A144,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":12330758.4},null,null,3.2160508287830306E-2,13198197.049999997]
["Q32021","2021Q3",null,null,2.4994421260489084E-2,{"$f":"IFERROR(VLOOKUP(A145,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":9579150.3999999985},null,null,2.4460156524578711E-2,10038086.550000001]
["Q42021","2021Q4",null,null,2.9083860056902833E-2,{"$f":"IFERROR(VLOOKUP(A146,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":11146434.110000001},null,null,3.2073199269745847E-2,13162366.719999999]
["Q12022","2022Q1",null,null,0.17660143794602942,{"$f":"IFERROR(VLOOKUP(A147,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":67682772.779999956},null,null,0.17431526639065353,71536407.759999976]
["Q22022","2022Q2",null,null,0.144861405355034,{"$f":"IFERROR(VLOOKUP(A148,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":55518356.460000016},null,null,0.14115686844491698,57928691.550000027]
["Q32022","2022Q3",null,null,9.1128389135717136E-2,{"$f":"IFERROR(VLOOKUP(A149,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":34925095.330000013},null,null,8.8528546259242502E-2,36330806.329999998]
["Q42022","2022Q4",null,null,0.10883877414286509,{"$f":"IFERROR(VLOOKUP(A150,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":41712627.629999973},null,null,0.11043002055977658,45318847.529999979]
["Q12023","2023Q1",null,null,0.1901408154822353,{"$f":"IFERROR(VLOOKUP(A151,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":72871760.050000042},null,null,0.1873616329699512,76890443.689999938]
["Q22023","2023Q2",null,null,4.7115311511708946E-2,{"$f":"IFERROR(VLOOKUP(A152,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":18057015.619999994},null,null,4.4645410582854948E-2,18321816.340000004]
["Q32023","2023Q3",null,null,2.7983766338458413E-3,{"$f":"IFERROR(VLOOKUP(A153,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":1072482.1499999999},null,null,2.7347714389514164E-3,1122309.7599999998]
["Q42023","2023Q4",null,null,9.9495280194314539E-3,{"$f":"IFERROR(VLOOKUP(A154,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":3813171.9200000009},null,null,9.3571542213976948E-3,3840037.7300000004]
["Q12024","2024Q1",null,null,2.9097796830704235E-3,{"$f":"IFERROR(VLOOKUP(A155,'[8]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":1115177.54},null,null,3.0324900849286384E-3,1244489.0900000001]
[]
[null,null,null,null,{"$f":"SUM(E134:E155)","v":0.99999999999999989},{"$f":"SUM(F134:F156)","v":383251538.42000008},{"$f":"F131-F157","v":0},null,1,410385213.18999988,0]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F160/F$171","v":0},{"$f":"IFERROR(VLOOKUP(A160,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F161/F$171","v":0.21786977164980006},{"$f":"IFERROR(VLOOKUP(A161,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":83498925.159999996},null,null,0.43992517129610625,180538785.20999968]
["13 to 18 months","13 to 18 months",null,null,0.58043296889840068,{"$f":"IFERROR(VLOOKUP(A162,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":222451828.28000012},null,null,0.51358685704501394,210768451.8199999]
["19 to 24 months","19 to 24 months",null,null,0.20053466148327737,{"$f":"IFERROR(VLOOKUP(A163,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":76855217.519999981},null,null,4.6458271587804363E-2,19065787.689999998]
["25 to 30 months","25 to 30 months",null,null,1.1625979685219391E-3,{"$f":"IFERROR(VLOOKUP(A164,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":445567.45999999996},null,null,2.9700071075311855E-5,12188.469999999998]
["31 to 36 months","31 to 36 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A165,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["37 to 42 months","37 to 42 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A166,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["43 to 48 months","43 to 48 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A167,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["49 to 54 months","49 to 54 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A168,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["55 to 60 months","55 to 60 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A169,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["60+ months","61 to 72 months",null,null,0,{"$f":"IFERROR(VLOOKUP(A170,'[8]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0]
["61 to 72 months","Total",null,null,{"$f":"SUM(E160:E170)","v":1},{"$f":"SUM(F160:F170)","v":383251538.42000008},{"$f":"F157-F171","v":0},null,0.99999999999999989,410385213.18999964,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F174/$J$180","v":1.1440246234764695E-2},{"$f":"IFERROR(VLOOKUP(A174,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":4694907.8900000006},null,null,1.2729459839434824E-2,5223982.09]
["13 - 24 months","13-24 Months",null,null,{"$f":"F175/$J$180","v":8.621010904605883E-2},{"$f":"IFERROR(VLOOKUP(A175,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":35379353.979999974},null,null,6.5982089387473686E-2,27078073.820000004]
["25 - 36 months","25-36 Months",null,null,0.14333370360195374,{"$f":"IFERROR(VLOOKUP(A176,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":58822032.510000013},null,null,0.14296399846852428,58670310.990000129]
["37 - 48 months","37-48 Months",null,null,0.51795043059114643,{"$f":"IFERROR(VLOOKUP(A177,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":212559197.87999979},null,null,0.47901013677358767,196578677.0999997]
["49 - 60 months","49-60 Months",null,null,0.17410865775253809,{"$f":"IFERROR(VLOOKUP(A178,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":71451618.63000004},null,null,0.29353324710125128,120461704.18999986]
["60+ Months","60+ Months",null,null,8.3927860685501193E-4,{"$f":"IFERROR(VLOOKUP(A179,'[8]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":344427.53},null,null,5.7810684297282386E-3,2372465]
[null,null,null,null,{"$f":"SUM(E174:E179)","v":0.93388242583331682},{"$f":"SUM(F174:F179)","v":383251538.41999978},{"$f":"F171-F180","v":0},null,1,410385213.1899997,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F183/F$199","v":1.0180997618655297E-4},{"$f":"IFERROR(VLOOKUP(A183,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":39018.83},null,null,9.5078547535130394E-5,39018.83]
["02. 21% to 30%","21% to 30%",null,null,5.5423815355235429E-3,{"$f":"IFERROR(VLOOKUP(A184,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":2124126.2500000005},null,null,5.6091699116221794E-3,2301920.3899999997]
["03. 31% to 40%","31% to 40%",null,null,3.0010222157009863E-2,{"$f":"IFERROR(VLOOKUP(A185,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":11501463.810000004},null,null,2.969824101424761E-2,12187718.969999997]
["04. 41% to 50%","41% to 50%",null,null,8.4721443060241514E-2,{"$f":"IFERROR(VLOOKUP(A186,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":32469623.390000004},null,null,8.2704000434553337E-2,33940498.849999994]
["05. 51% to 60%","51% to 60%",null,null,0.13197393839179036,{"$f":"IFERROR(VLOOKUP(A187,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":50579214.919999972},null,null,0.13161775661978506,54013981.109999977]
["06. 61% to 70%","61% to 70%",null,null,0.16673158083966436,{"$f":"IFERROR(VLOOKUP(A188,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":63900134.859999985},null,null,0.16608362562625806,68158264.109999999]
["07. 71% to 80%","71% to 80%",null,null,0.17669058219354097,{"$f":"IFERROR(VLOOKUP(A189,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":67716937.450000063},null,null,0.17856535923986283,73280583.019999981]
["08. 81% to 90%","81% to 90%",null,null,0.21375833774272157,{"$f":"IFERROR(VLOOKUP(A190,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":81923211.790000021},null,null,0.2111981616888145,86672602.610000148]
["09. 91% to 100%","91% to 100%",null,null,0.19046970410332101,{"$f":"IFERROR(VLOOKUP(A191,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":72997807.11999999},null,null,0.19442860691732233,79790625.299999967]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP(A192,'[8]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E183:E192)","v":0.99999999999999967},{"$f":"SUM(F183:F192)","v":383251538.42000008},{"$f":"F180-F193","v":0},null,1.0000000000000009,410385213.19000006,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F196/F$199","v":0.94991349691866422},{"$f":"IFERROR(VLOOKUP(A196,'[8]New v Used'!$A$1:$C$4,3,FALSE),0)","v":364055809.06000012},null,null,0.9490331846817387,389469185.81999964]
["USed","Used",null,null,{"$f":"F197/F$199","v":5.0086503081335748E-2},{"$f":"IFERROR(VLOOKUP(A197,'[8]New v Used'!$A$1:$C$4,3,FALSE),0)","v":19195729.360000003},null,null,5.0966815318261298E-2,20916027.370000001]
["Used"]
[null,null,null,null,{"$f":"SUM(E196:E197)","v":1},{"$f":"SUM(F196:F197)","v":383251538.42000014},{"$f":"F193-F199","v":0},null,1,410385213.18999964,0]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F202/F$205","v":0},{"$f":"IFERROR(VLOOKUP(A201,'[8]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":0},null,null,1.4946478827345518E-2,6133813.9000000022]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F203/F$205","v":1.5384156033356971E-2},{"$f":"IFERROR(VLOOKUP(A202,'[8]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":5867930.8300000001},null,null,0.98060734272529604,402426753.39999944]
["Hire Purchase","Hire Purchase",null,null,0.98461584396664303,{"$f":"IFERROR(VLOOKUP(A203,'[8]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":375558961.69999999},null,null,4.446178447358503E-3,1824645.89]
[null,null,null,null,{"$f":"SUM(E202:E204)","v":1},{"$f":"SUM(F202:F204)","v":381426892.52999997},{"$f":"F199-F205","v":1824645.8900001645},null,1,410385213.1899994,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F208/F$210","v":1},{"$f":"IFERROR(VLOOKUP($A208,'[1]Refinance vs Hardship'!$A$1:$C$2,3,FALSE),0)","v":410385213.18999952},null,null,1,410385213.18999952]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F209/F$210","v":0},{"$f":"IFERROR(VLOOKUP($A209,'[1]Refinance vs Hardship'!$A$1:$C$2,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E208:E209)","v":1},{"$f":"SUM(F208:F209)","v":410385213.18999952},{"$f":"F205-F210","v":-28958320.659999549},null,1,410385213.18999952,0]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F213/F$219","v":1.1712234342242514E-2},{"$f":"IFERROR(VLOOKUP(A213,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":4488731.8299999991},null,null,1.2388169959832968E-2,5083921.7699999996]
["Annual","Annual",null,null,0.69340474860343537,{"$f":"IFERROR(VLOOKUP(A214,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":265748436.64999989},null,null,0.68479321044613084,281029007.65999955]
["Monthly","Monthly",null,null,0.23977651896414276,{"$f":"IFERROR(VLOOKUP(A215,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":91894719.769999996},null,null,0.24760382397831499,101612948.0899999]
["Quarterly","Quarterly",null,null,1.3970175650364975E-2,{"$f":"IFERROR(VLOOKUP(A216,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":5354091.3099999996},null,null,1.4114368826730304E-2,5792328.2599999988]
["Semi Annual","Semi Annual",null,null,3.2817316355340312E-2,{"$f":"IFERROR(VLOOKUP(A217,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":12577286.979999999},null,null,3.2746301933101622E-2,13438598.100000001]
["Structured","Structured",null,null,8.3190060844739993E-3,{"$f":"IFERROR(VLOOKUP(A218,'[8]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":3188271.88},null,null,8.3541248558892875E-3,3428409.3099999987]
["0% to 1%",null,null,null,{"$f":"SUM(E213:E218)","v":1},{"$f":"SUM(F213:F218)","v":383251538.4199999},{"$f":"F210-F219","v":27133674.769999623},null,1,410385213.18999946,0]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F222/F$236","v":0.18439888484557762},{"$f":"IFERROR(VLOOKUP(A222,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":70671156.300000027},null,null,0.18563182498178873,76180556.070000097]
["02. 1.01% to 2%",null,null,null,0.12894250150626699,{"$f":"IFERROR(VLOOKUP(A223,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":49417412.069999978},null,null,0.12910621702997338,52983282.399999999]
["03. 2.01% to 3%",null,null,null,0.33889215799485012,{"$f":"IFERROR(VLOOKUP(A224,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":129880940.90999998},null,null,0.33208506944158278,136282802.01999983]
["04. 3.01% to 4%",null,null,null,0.27863191756578037,{"$f":"IFERROR(VLOOKUP(A225,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":106786111.05999993},null,null,0.28307789512439169,116170982.33999988]
[null,"< 4%",null,null,{"$f":"SUM(E222:E225)","v":0.93086546191247499},{"$f":"SUM(F222:F225)","v":356755620.33999991},null,null,0.92990100657773667,381617622.8299998]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F227/F$236","v":2.7083948919794664E-2},{"$f":"IFERROR(VLOOKUP(A227,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":10379965.09},null,null,2.6961732597507792E-2,11064696.380000001]
["06. 5.01% to 6%","5% to 6%",null,null,3.2514800492056462E-2,{"$f":"IFERROR(VLOOKUP(A228,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":12461347.310000008},null,null,3.3558998344377006E-2,13772116.690000005]
["07. 6.01% to 7%","6% to 7%",null,null,9.2778218573080218E-3,{"$f":"IFERROR(VLOOKUP(A229,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":3555739.5},null,null,9.3239895761752112E-3,3826427.4499999993]
["08. 7.01% to 8%","7% to 8%",null,null,2.5796681836578555E-4,{"$f":"IFERROR(VLOOKUP(A230,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":98866.180000000008},null,null,2.5427290420351528E-4,104349.84]
["09. 8.01% to 9%","8% to 9%",null,null,0,{"$f":"IFERROR(VLOOKUP(A231,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP(A232,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP(A233,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP(A234,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP(A235,'[8]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E226:E235)","v":1},{"$f":"SUM(F226:F235)","v":383251538.4199999},{"$f":"F219-F236","v":0},null,1.0000000000000002,410385213.18999976,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F238/E13","v":2.6533466902501881E-2},{"$f":"SUM('[8]Top 5 Obligor '!$E$2:$E$6)","v":10168992.009999998},null,null,2.641781343856708E-2,10841479.999999998]